Goal¶
- What we have in dev-pre-restructure is working fine but we're on a short deadline and need to streamline the data. Let's make a barebones table of the core data we need for analysis, including:
event_no
date_occurred (w/ year_occurred)
source_type (a field derived from the initial event type in the data, either 911 call reporting gunfire or Shotspotter GDT alert)
event_location (service address if specified)
date_dispatched (is this the same as date of arrival?)
Research questions we're working towards¶
- Is dispatch reported at the same rate for all districts?
- RE: Soundthinking / Brookings Institute claim that some 80% of gunfire events do not get reported by citizens - is that True in Chicago?
- When SST alerts aren't matched to 911 calls, what is the typical disposition of such an alert?
- When 911 calls aren't matched to SST alert, what is the typical disposition?
Time period covered¶
- Earliest date occurred included: '2021-01-01'
- Last date occurred included: '2024-11-05' (when the SST technology was reportedly deactivated; CPD and OEMC_sst only cover to this date)
- Does it make sense to extend to end of 2024 anyways? the Dec 2024 911 calls won't have a SST match and could be ignored or addressed differently depending on how we handle analysis
Identifying Event type (based on the _inittype field)¶
shotspotter = ['SST', 'PSST', 'MSST'] # keywords provided by CPD in Info sheet
citizencalls = ['SHOTS', 'SHOTSF', 'PERSHO',] # Note: 'PERGUN', 'PERDOW','PERHLP', 'DOMBAT', etc. excluded
Note about what humans can do that SST can't¶
In the OEMC data, in addition to reports originating as calls about shots fired ('SHOTSF') or persons being shot ('PERSHO'), we also see events with an initial label 'PERGUN' and final label referring to shots fired or someone shot. This tells us that not only do Chicagoans report gunfire in general, they may also report early warning signs of conflict involving firearms before any shots occur, giving first responders a head start to arrive on scene and provide potentially life-saving care.
Review data¶
Sample emergency event record.
|
230684 |
| event_no |
2215502048 |
| date_occurred |
2022-06-04 02:49:00 |
| date_dispatched |
2022-06-04 02:49:00 |
| location |
92XX S STONY ISLAND AV |
| location_x |
41.726 |
| location_y |
-87.584 |
| init_type |
SST |
| init_type_desc |
SHOT SPOTTER |
| fin_type |
SST |
| fin_type_desc |
SHOT SPOTTER |
| disposition |
MISC.INC./NO PERSON FND. |
| source_type |
ShotSpotter alert |
| early_warning |
False |
Counts¶
Overall¶
- There are 394,199 gunfire-related 911 calls and ShotSpotter alerts prepared for this analysis.
- The data cover a time period between 2021-01-01 and 2024-11-04.
Source type¶
|
source_type |
count |
percent |
| 0 |
Human reporting gunfire |
237,302 |
60.2% |
| 1 |
ShotSpotter alert |
156,897 |
39.8% |
- Summary: Of the 394,199 emergency events included in the analysis,
- 237,302 or 60.2%
were generated by a 911 call, and
- 156,897 or 39.8%
were generated by a ShotSpotter alert.
5 most frequently reported disposition values¶
Presented are:
- the initial event type as reported by OEMC and CPD (
init_type),
- the description of the initial type as found in the data (
init_type_desc), and
- the type of source which reported the event (
source_type).
|
init_type |
init_type_desc |
source_type |
count |
percent |
| 0 |
SHOTSF |
SHOTS FIRED |
Human reporting gunfire |
191,216 |
48.5% |
| 1 |
SST |
SHOT SPOTTER |
ShotSpotter alert |
113,791 |
28.9% |
| 2 |
MSST |
Multiple Shot - ShotSpotter |
ShotSpotter alert |
38,855 |
9.9% |
| 3 |
PERSHO |
PERSON SHOT |
Human reporting gunfire |
32,468 |
8.2% |
| 4 |
SHOTS |
SHOTS FIRED (OV) |
Human reporting gunfire |
13,618 |
3.5% |
| 5 |
PSST |
Probable Shot - ShotSpotter |
ShotSpotter alert |
4,251 |
1.1% |
Disposition¶
In the info page included with the data, the CPD FOIA officer informed us that they had internally
identified emergency events from both sources, 911 callers and ShotSpotter, that referred to the same underlying gunfire event,
and that the disposition field was only included in the responsive records when ShotSpotter was the first to report.
Source
- Of the 394,199 emergency events included in the analysis, 123,216 or 31.3%
have a reported disposition.
5 most frequently reported disposition values¶
Presented are the 5 most frequently reported `disposition` values
for emergency events in which ShotSpotter was the first alert.
|
disposition |
count |
percent |
| 0 |
MISC.INC./OTH POLICE SER |
87,415 |
70.9% |
| 1 |
MISC.INC./NO PERSON FND. |
15,671 |
12.7% |
| 2 |
WEAP VIO/DISC OF FIREA |
5,435 |
4.4% |
| 3 |
BATTERY:AGGR:HANDGUN |
2,746 |
2.2% |
| 4 |
ASSAULT;AGG HAND |
1,314 |
1.1% |
- Of the 123,216 emergency events about potential gunfire
identified by CPD as first reported by ShotSpotter, 104,586 or 84.9%
are labeled as a "Miscellaneous Incident."